iT邦幫忙

2018 iT 邦幫忙鐵人賽
0

測試用,正式機不要裝

收集到很多監控數據,想要做分析,試著用python測試看看

python新手用Anaconda最方便
安裝Anaconda,其中一個步驟選yes會建立路徑,否則要自己手動建

wget https://repo.continuum.io/archive/Anaconda2-5.0.1-Linux-x86_64.sh
yum install bzip2
bash Anaconda2-5.0.1-Linux-x86_64.sh

手動建,改成自己anaconda2的路徑
vi ~/.bashrc

export PATH="/root/anaconda2/bin:$PATH"

重整source,輸入python,顯示Python 2.7.14 |Anaconda即成功了

source ~/.bashrc

設定ipython,首先設定密碼

ipython
from notebook.auth import passwd
passwd()

output一組密碼記下來
Out[2]: 'sha1:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'

設定config

jupyter notebook --generate-config --allow-root

依照上個命令產生的config路徑(Writing default config to: /root/.jupyter/jupyter_notebook_config.py)
vi /root/.jupyter/jupyter_notebook_config.py

c.NotebookApp.allow_root = True
c.NotebookApp.ip = '0.0.0.0'
c.NotebookApp.password = u'sha1:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'

啟動,預設 http://0.0.0.0:8888

jupyter notebook

1-12有草草帶過撈Zabbix SQL資料,下面詳細帶過步驟
參考教學,要用mysql-connector-python套件,先來安裝
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html

一般沒裝Anaconda用pip安裝

yum install python-pip
sudo pip install mysql-connector-python

查相關套件

# pip search mysql-connector | grep --color mysql-connector-python
mysql-connector-python-rf (2.2.2) - MySQL driver written in Python
mysql-connector-python (8.0.5) - MySQL driver written in Python

有裝Anaconda用conda安裝

conda install -c mysql-connector-python

回到jupyte notebook網頁,右上new一個python2
import測試套件是否安裝成功

import mysql.connector

依照教學,連上zabbix sql
https://docs.microsoft.com/zh-tw/azure/mysql/connect-python

import mysql.connector
from mysql.connector import errorcode

# Obtain connection string information from the portal
config = {
  'host':'127.0.0.1',
  'user':'zabbix',
  'password':'zabbix',
  'database':'zabbix'
}

# Construct connection string
try:
   conn = mysql.connector.connect(**config)
   print("Connection established")
except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with the user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
  cursor = conn.cursor()

上一篇
1-15.監控工具之一:Zabbix SnmpTrap
下一篇
1-16.監控工具之一:Zabbix -> Elasticsearch
系列文
成長型維運平台 - 單人新手到多人團隊都適用的工具27
圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

立即登入留言